2016-07-26 - 27719 - Enhancement - GLPCA Hierarchy #BExQueriesforCrystalReportsAnalysisTool
SPECIFICATIONS
27719 - GLPCA Hierachy
Purpose
Need to add new Hierachy 0010 FIN2 to all GLPCA Queries.
Admin Info
Purpose
|
Need to add new Hierachy 0010FIN2 to all GLPCA Queries.
|
Requested By
|
Don Sauer
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
07/26/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
GLPCA Queries
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
08
|
2
|
Documentation
|
06
|
3
|
Development/ Config
|
08
|
4
|
Unit test in DEV
|
04
|
5
|
Unit test in QUA
|
04
|
6
|
Transports
|
02
|
|
TOTAL
|
32
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
01
|
Need to make changes to the GLPC Analysis BEx query only.
|
Saravanan
|
08/29/2016
|
Weekly Meeting
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to add new Hierachy 0010 FIN2 to all GLPCA Queries.
In Scope:
GLPCA Queries where GL Hierarchy used.
Out of Scope:
Other Queries where GL Hierarchy is not used.
Solution Summary
1. Need to replace existing hierarchy 0010 New Era Cap with 0010 FIN2.
2. As GL Account does not hold 0010FIN2 Hierarchy, need to replace existing GL Account with 0ACCOUNT.
3. Need to switch on 0010FIN2 Hierarchy on 0ACCOUNT object.
4. Need to create a new transport request & collect all the Query changes.
Solution Details
1. Need to replace existing hierarchy 0010 New Era Cap with 0010 FIN2.
2. As GL Account does not hold 0010FIN2 Hierarchy, need to replace existing GL Account with 0ACCOUNT.
3. Need to switch on 0010FIN2 Hierarchy on 0ACCOUNT object.
4. As a part of initial stage the changes were made to one Analysis query, once approved need to make changes to all other queries.
5. Need to create a new transport request & collect all the Query changes.
Issues
If changes were applied to report queries, the corresponding reports needs to be updated with BEx Queries.